﻿using System;
using Microsoft.EntityFrameworkCore.Migrations;
using Oracle.EntityFrameworkCore.Metadata;

namespace SOEI.Solution.Migrations
{
    public partial class NCLF_NewEntityEx_Initial : Migration
    {
        protected override void Up(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.CreateTable(
                name: "NCLF_ECONOMYORGANIES",
                schema: "FGXT_YW",
                columns: table => new
                {
                    ID = table.Column<long>(nullable: false)
                        .Annotation("Oracle:ValueGenerationStrategy", OracleValueGenerationStrategy.IdentityColumn),
                    CREATIONTIME = table.Column<DateTime>(nullable: false),
                    CREATORUSERID = table.Column<long>(nullable: true),
                    LASTMODIFICATIONTIME = table.Column<DateTime>(nullable: true),
                    LASTMODIFIERUSERID = table.Column<long>(nullable: true),
                    JGBH = table.Column<string>(nullable: true),
                    DZ = table.Column<string>(nullable: true),
                    ZGBM = table.Column<string>(nullable: true),
                    ZCZJ = table.Column<string>(nullable: true),
                    FRXM = table.Column<string>(nullable: true),
                    FRDH = table.Column<string>(nullable: true),
                    LXRXM = table.Column<string>(nullable: true),
                    LXRDH = table.Column<string>(nullable: true),
                    YWLXDH = table.Column<string>(nullable: true),
                    YZBH = table.Column<string>(nullable: true),
                    RYZS = table.Column<decimal>(nullable: true),
                    JJRS = table.Column<decimal>(nullable: true),
                    YYZZH = table.Column<string>(nullable: true),
                    SWDJZH = table.Column<string>(nullable: true),
                    FRDMZH = table.Column<string>(nullable: true),
                    FZJGS = table.Column<decimal>(nullable: true),
                    YWFW = table.Column<string>(nullable: true),
                    ZJLY = table.Column<string>(nullable: true),
                    GDZJ = table.Column<decimal>(nullable: true),
                    LDZJ = table.Column<decimal>(nullable: true),
                    ZJZJ = table.Column<decimal>(nullable: true),
                    ZYMJ = table.Column<decimal>(nullable: true),
                    ZLMJ = table.Column<decimal>(nullable: true),
                    QTMJ = table.Column<decimal>(nullable: true),
                    MJHJ = table.Column<decimal>(nullable: true),
                    JGLXDM = table.Column<string>(nullable: true),
                    SJDW = table.Column<string>(nullable: true),
                    FZRXM = table.Column<string>(nullable: true),
                    FZRDH = table.Column<string>(nullable: true),
                    JJXZDM = table.Column<string>(nullable: true),
                    LRSJ = table.Column<string>(nullable: true),
                    JGZT = table.Column<string>(nullable: true),
                    GLYBH = table.Column<string>(nullable: true),
                    BGMJ = table.Column<decimal>(nullable: true),
                    ZCDZ = table.Column<string>(nullable: true),
                    ZCDZYB = table.Column<string>(nullable: true),
                    BGCSDM = table.Column<string>(nullable: true),
                    SGRS = table.Column<decimal>(nullable: true),
                    KZJQDMMHTBH = table.Column<string>(nullable: true),
                    JJHTJYBH = table.Column<string>(nullable: true),
                    JYGPXXBH = table.Column<string>(nullable: true),
                    JJRXLZS = table.Column<decimal>(nullable: true),
                    XGSJ = table.Column<DateTime>(nullable: true),
                    EMAIL = table.Column<string>(nullable: true),
                    QQ = table.Column<string>(nullable: true),
                    NJYQSJ = table.Column<string>(nullable: true),
                    SFFZJG = table.Column<string>(nullable: true),
                    ZGS = table.Column<string>(nullable: true),
                    YZGSGX = table.Column<string>(nullable: true),
                    PYJC = table.Column<string>(nullable: true),
                    JGZP = table.Column<string>(nullable: true),
                    KWQ = table.Column<string>(nullable: true),
                    JGMC = table.Column<string>(nullable: true),
                    SFYQ = table.Column<string>(nullable: true),
                    WQKTSJ = table.Column<DateTime>(nullable: true),
                    ZGSJGBH = table.Column<string>(nullable: true),
                    FRZJLX = table.Column<string>(nullable: true),
                    FRZJHM = table.Column<string>(nullable: true),
                    JGQC = table.Column<string>(nullable: true),
                    SFGTGSH = table.Column<string>(nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_NCLF_ECONOMYORGANIES", x => x.ID);
                });
        }

        protected override void Down(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.DropTable(
                name: "NCLF_ECONOMYORGANIES",
                schema: "FGXT_YW");
        }
    }
}
